{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["BExRepositorySheet","Table","Sheet1","Estado Situacion Financiera Det","Graph"],"not_rendered":{"charts":1,"images":21,"macros":1,"external_links":1,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BExRepositorySheet","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[7]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Filter"]

{"sheet":"Table","index":1,"n_rows":67,"n_cols":12,"rows_kept":67,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,"Estado de Situacion Financiera Det A"]
[null,null,null,null,null,null,null,"Autor","ADVJYNOQUIO",null,"Actualidad de datos","24/01/2019 14:01:09"]
[]
[]
[null,null,null,null,null,null,"Information"]
[null,null,null,null,null,null,"Autor","ADVJYNOQUIO",null,"Últ.actual.pantalla","29/10/2019 11:34:50"]
[null,null,null,null,null,null,"Usuario actual","GRPAARROYO",null,"Fe.clave","29/10/2019"]
[null,null,null,null,null,null,"Modificado por","ADVIVIEYRA",null,"Hora de modificación","24/01/2019 17:25:44"]
[null,null,null,null,null,null,"InfoSitio","ZVRL_MP02",null,"Actualidad de datos","24/01/2019 14:01:09"]
[null,null,null,null,null,null,"Nombre técnico query","ZFI_VRL_MP02_Q008A",null,"Actualidad datos (fecha)","24/01/2019"]
[null,null,null,null,null,null,"Descripción query","Estado de Situacion Financiera Det A",null,"Actualidad datos (fecha)","14:01:09"]
[]
[]
[null,null,"Filter",null,null,null,"Table"]
[null,null,"Área funcional","",null,null,"","Saldo Actual (ORIGINAL)","Saldo Anterior (ORIGINAL)","Saldo Actual (NUEVO)","Saldo Anterior (NUEVO)","Saldo acumulado"]
[null,null,"Centro de beneficio","",null,null,"Activo",0,0,0,0,0]
[null,null,"Centro de coste","",null,null,"  Activo Circulante",0,0,0,0,0]
[null,null,"Ejercicio/Período","",null,null,"    a. Efectivo y Equivalentes",0,0,4861883606.6099997,2221588920.1100001,4371098025.3100004]
[null,null,"Ejercicio","",null,null,"    a1) Efectivo",0,0,1393323329.46,583704758.58000004,1450988285.29]
[null,null,"Estruct.","",null,null,"    a2) Bancos/Tesorería",0,0,3050010423.3899999,1636771067,2787516724.04]
[null,null,"Período contable","",null,null,"    a3) Bancos/Dependencias y Otros",0,0,0,0,0]
[null,null,"Ratios","",null,null,"    a4) Inversiones Temporales (Hasta 3 meses)",0,0,1133935.9099999999,1084088.53,782872.66]
[null,null,null,null,null,null,"    a5) Fondos con Afectación Específica",0,0,417386911.85000002,0,131781137.31999999]
[null,null,null,null,null,null,"    a6) Depósitos de Fondos de Terceros en Garantía y/o",0,0,0,0,0]
[null,null,null,null,null,null,"    a7) Otros Efectivos y Equivalentes",0,0,29006,29006,29006]
[null,null,null,null,null,null,"    b. Derechos a Recibir Efectivo o Equivalentes",0,0,5179794576.3100004,2890381899.8000002,5353992569.9799995]
[null,null,null,null,null,null,"    b1) Inversiones Financieras de Corto Plazo",0,0,-0.05,1224815.6599999999,-0.05]
[null,null,null,null,null,null,"    b2) Cuentas por Cobrar a Corto Plazo",0,0,99588109.969999999,99588109.969999999,99588109.969999999]
[null,null,null,null,null,null,"    b3) Deudores Diversos por Cobrar a Corto Plazo",0,0,4548475347.8800001,2421868811,4725660117.7600002]
[null,null,null,null,null,null,"    b4) Ingresos por Recuperar a Corto Plazo",0,0,14458429.15,14751538.130000001,14478449.15]
[null,null,null,null,null,null,"    b5) Deudores por Anticipos de la Tesorería a Corto Plazo",0,0,47615245.520000003,38353502.740000002,47615245.520000003]
[null,null,null,null,null,null,"    b6) Préstamos Otorgados a Corto Plazo",0,0,47149642.299999997,47149642.299999997,47149642.299999997]
[null,null,null,null,null,null,"    b7) Otros Derechos a Recibir Efectivo o Equivalentes a C",0,0,422507801.54000002,267445480,419501005.32999998]
[null,null,null,null,null,null,"    c. Derechos a Recibir Bienes o Servicios",0,0,17733825.34,107853768.78,17733825.34]
[null,null,null,null,null,null,"    c1) Anticipo a Proveedores por Adquisición de Bienes y",0,0]
[null,null,null,null,null,null,"    c2) Anticipo a Proveedores por Adquisición de Bienes Inm",0,0]
[null,null,null,null,null,null,"    c3) Anticipo a Proveedores por Adquisición de Bienes Int",0,0]
[null,null,null,null,null,null,"    c4) Anticipo a Contratistas por Obras Públicas a Corto P",0,0,17733825.34,107853768.78,17733825.34]
[null,null,null,null,null,null,"    c5) Otros Derechos a Recibir Bienes o Servicios a Corto",0,0]
[null,null,null,null,null,null,"    d. Inventarios",0,0]
[null,null,null,null,null,null,"    d1) Inventario de Mercancías para Venta",0,0]
[null,null,null,null,null,null,"    d2) Inventario de Mercancías Terminadas",0,0]
[null,null,null,null,null,null,"    d3) Inventario de Mercancías en Proceso de Elaboración",0,0]
[null,null,null,null,null,null,"    d4) Inventario de Materias Primas, Materiales y Suminist",0,0]
[null,null,null,null,null,null,"    d5) Bienes en Tránsito",0,0]
[null,null,null,null,null,null,"    e. Almacenes",0,0,638414.19999999995,698324.4,638414.19999999995]
[null,null,null,null,null,null,"    f. Estimación por Pérdida o Deterioro de Activos Circ.",0,0]
[null,null,null,null,null,null,"    f1) Estimaciones para Cuentas Incobrables por Derechos a",0,0]
[null,null,null,null,null,null,"    f2) Estimación por Deterioro de Inventarios",0,0]
[null,null,null,null,null,null,"    g. Otros Activos Circulantes",0,0,75108659.879999995,394589219.87,75108659.879999995]
[null,null,null,null,null,null,"    g1) Valores en Garantía",0,0,75108659.879999995,394589219.87,75108659.879999995]
[null,null,null,null,null,null,"    g2) Bienes en Garantía (excluye depósitos de fondos)",0,0]
[null,null,null,null,null,null,"    g3) Bienes Derivados de Embargos, Decomisos, Aseguramien",0,0]
[null,null,null,null,null,null,"    g4) Adquisición con Fondos de Terceros",0,0,0,0,0]
[null,null,null,null,null,null,"  IA. Total de Activos Circulantes",0,0,10135159082.34,5615112132.96,9818571494.7099991]
[null,null,null,null,null,null,"  Activo No Circulante",0,0,0,0,0]
[null,null,null,null,null,null,"    a. Inversiones Financieras a Largo Plazo",0,0,11690592336.23,11002813539.110001,11690592336.23]
[null,null,null,null,null,null,"    b. Derechos a Recibir Efectivo o Equivalentes a LP",0,0,188957243.97999999,175533492.78999999,188957243.97999999]
[null,null,null,null,null,null,"    c. Bienes Inmuebles, Infra. y Construcc. en Proceso",0,0,14669656681.950001,14398312859.290001,14682855864.24]
[null,null,null,null,null,null,"    d. Bienes Muebles",0,0,2800916666.1399999,2721731355.0300002,2809810762.2199998]
[null,null,null,null,null,null,"    e. Activos Intangibles",0,0,51869060.130000003,51836953.649999999,52209120.140000001]
[null,null,null,null,null,null,"    f. Depreciación, Deterioro y Amort. Acum. de Bien",0,0,-732137726.67999995,-564929011.46000004,-703852430.35000002]
[null,null,null,null,null,null,"    g. Activos Diferidos",0,0,32457644.670000002,32457644.670000002,32457644.670000002]
[null,null,null,null,null,null,"    h. Estimación por Pérdida o Det. de Activos no Circulant",0,0]
[null,null,null,null,null,null,"    i. Otros Activos no Circulantes",0,0]
[null,null,null,null,null,null,"  IB. Total de Activos No Circulantes",0,0,28702311906.419998,27817756833.080002,28753030541.130001]
[null,null,null,null,null,null,"I. Total del Activo",0,0,38837470988.760002,33432868966.040001,38571602035.839996]

{"sheet":"Sheet1","index":2,"n_rows":80,"n_cols":12,"rows_kept":80,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Table"]
[null,null,null,null,null,null,"","Saldo Actual (ORIGINAL)","Saldo Anterior (ORIGINAL)","Saldo Actual (NUEVO)","Saldo Anterior (NUEVO)","Saldo acumulado"]
[null,null,null,null,null,null,"Pasivo",null,null,null,null,0]
[null,null,null,null,null,null,"  Pasivo Circulante",null,null,null,null,0]
[null,null,null,null,null,null,"    a. Cuentas por Pagar a Corto Plazo",0,0,6243655255.2399998,5957743888.4899998,-6899903718.8900003]
[null,null,null,null,null,null,"    a1) Servicios Personales por Pagar a Corto Plazo",0,0,341914190.55000001,427068145,-380933829.93000001]
[null,null,null,null,null,null,"    a2) Proveedores por Pagar a Corto Plazo",0,0,888222693.88,1391584150.02,-1024868736.17]
[null,null,null,null,null,null,"    a3) Contratistas por Obras Públicas por Pagar a Corto Pl",0,0,51499469.07,278284519,-52907551.899999999]
[null,null,null,null,null,null,"    a4) Participaciones y Aportaciones por Pagar a Corto Pla",0,0,144541572.72,168115975.56,-368327789.68000001]
[null,null,null,null,null,null,"    a5) Transferencias Otorgadas por Pagar a Corto Plazo",0,0,1044704214.0599999,786381168.23000002,-1337916089.1700001]
[null,null,null,null,null,null,"    a6) Intereses, Comisiones y Otros Gastos de la Deuda Púb",0,0,6805285.0599999996,6263645.79,-6738207.9800000004]
[null,null,null,null,null,null,"    a7) Retenciones y Contribuciones por Pagar a Corto Plazo",0,0,1477094594.9200001,1368271953.0999999,-1289204798.8]
[null,null,null,null,null,null,"    a8) Devoluciones de la Ley de Ingresos por Pagar a Corto",0,0,6941012.3499999996,12038276.789999999,7857761.2400000002]
[null,null,null,null,null,null,"    a9) Otras Cuentas por Pagar a Corto Plazo",0,0,2281932222.6300001,1519736055,-2446864476.5]
[null,null,null,null,null,null,"    b. Documentos por Pagar a Corto Plazo",0,0,1811250000,3750582880,-1811250000]
[null,null,null,null,null,null,"    b1) Documentos Comerciales por Pagar a Corto Plazo",0,0,1811250000,3750582880,-1811250000]
[null,null,null,null,null,null,"    b2) Documentos con Contratistas por Obras Públicas por P",0,0]
[null,null,null,null,null,null,"    b3) Otros Documentos por Pagar a Corto Plazo",0,0]
[null,null,null,null,null,null,"    c. Porción a Corto Plazo de la Deuda Pública",0,0,131615170.33,461527733.06999999,-131615170.33]
[null,null,null,null,null,null,"    c1) Porción a Corto Plazo de la Deuda Pública",0,0,131615170.33,461527733.06999999,-131615170.33]
[null,null,null,null,null,null,"    c2) Porción a Corto Plazo de Arrendamiento Financiero",0,0]
[null,null,null,null,null,null,"    d. Títulos y Valores a Corto Plazo",0,0]
[null,null,null,null,null,null,"    e. Pasivos Diferidos a Corto Plazo",0,0]
[null,null,null,null,null,null,"    e1) Ingresos Cobrados por Adelantado a Corto Plazo",0,0]
[null,null,null,null,null,null,"    e2) Intereses Cobrados por Adelantado a Corto Plazo",0,0]
[null,null,null,null,null,null,"    e3) Otros Pasivos Diferidos a Corto Plazo",0,0]
[null,null,null,null,null,null,"    f. Fondos y Bienes de Terceros en Garantía",0,0,224089025.56999999,230227926.66,-226043705.99000001]
[null,null,null,null,null,null,"    f1) Fondos en Garantía a Corto Plazo",0,0,11906824.58,11872039.58,-11908132.58]
[null,null,null,null,null,null,"    f2) Fondos en Administración a Corto Plazo",0,0,212182200.99000001,218355887.08000001,-214135573.41]
[null,null,null,null,null,null,"    f3) Fondos Contingentes a Corto Plazo",0,0]
[null,null,null,null,null,null,"    f4) Fondos de Fideicomisos, Mandatos y Contratos Análogo",0,0]
[null,null,null,null,null,null,"    f5) Otros Fondos de Terceros en Garantía y/o Administrac",0,0]
[null,null,null,null,null,null,"    f6) Valores y Bienes en Garantía a Corto Plazo",0,0]
[null,null,null,null,null,null,"    g. Provisiones a Corto Plazo",0,0]
[null,null,null,null,null,null,"    g1) Provisión para Demandas y Juicios a Corto Plazo",0,0]
[null,null,null,null,null,null,"    g2) Provisión para Contingencias a Corto Plazo",0,0]
[null,null,null,null,null,null,"    g3) Otras Provisiones a Corto Plazo",0,0]
[null,null,null,null,null,null,"    h. Otros Pasivos a Corto Plazo",0,0,514890237.31,345630025.56999999,-546146414.71000004]
[null,null,null,null,null,null,"    h1) Ingresos por Clasificar",0,0,2605281.04,2476374.86,-2605281.04]
[null,null,null,null,null,null,"    h2) Recaudación por Participar",0,0,478346638.50999999,153892509,-506972900.13]
[null,null,null,null,null,null,"    h3) Otros Pasivos Circulantes",0,0,33938317.759999998,189261141.71000001,-36568233.539999999]
[null,null,null,null,null,null,"  IIA. Total de Pasivos Circulantes",0,0,8925499688.4500008,10745712453.790001,-9614959009.9200001]
[null,null,null,null,null,null,"  Pasivo No Circulante",null,null,null,null,0]
[null,null,null,null,null,null,"    a. Cuentas por Pagar a Largo Plazo",0,0,0,0,0]
[null,null,null,null,null,null,"    b. Documentos por Pagar a Largo Plazo",0,0]
[null,null,null,null,null,null,"    c. Deuda Pública a Largo Plazo",0,0,16827616192,16827616192,-16827616192]
[null,null,null,null,null,null,"    d. Pasivos Diferidos a Largo Plazo",0,0]
[null,null,null,null,null,null,"    e. Fondos y Bienes de Terceros en Garantía",0,0]
[null,null,null,null,null,null,"    f. Provisiones a Largo Plazo",0,0]
[null,null,null,null,null,null,"  IIB. Total de Pasivos No Circulantes",0,0,16827616192,16827616192,-16827616192]
[null,null,null,null,null,null,"II. Total del Pasivo",0,0,25753115880.450001,27573328645.790001,-26442575201.919998]
[null,null,null,null,null,null,"Hacienda Pública/Patrimonio",null,null,null,null,0]
[null,null,null,null,null,null,"  IIIA. Hacienda Pública/Patrimonio Contribuido",0,0,20673380847.639999,20521064614.09,-20673380847.639999]
[null,null,null,null,null,null,"    Aportaciones",0,0,20667806292.290001,20515490058.740002,-20667806292.290001]
[null,null,null,null,null,null,"    Donaciones de Capital",0,0]
[null,null,null,null,null,null,"    Actualización de la Hacienda Pública/Pa",0,0,5574555.3499999996,5574555.3499999996,-5574555.3499999996]
[null,null,null,null,null,null,"  IIIB. Hacienda Pública/Patrimonio Generado",0,0,9821370264.8999996,3102897954.6700001,-8874753904.7900009]
[null,null,null,null,null,null,"    Resultados del Ejercicio (Ahorro/ Desahorro)",0,0,6718472310.2299995,2944201639.4699998,-5771855950.1199999]
[null,null,null,null,null,null,"    Resultados de Ejercicios Anteriores",0,0,3102897954.6700001,158696315.19999999,-3102897954.6700001]
[null,null,null,null,null,null,"    Revalúos",0,0]
[null,null,null,null,null,null,"    Reservas",0,0]
[null,null,null,null,null,null,"    Rectificaciones de Resultados de Ejercicios Anteriores",0,0,-17410396004.23,-17764422248.509998,17419107918.509998]
[null,null,null,null,null,null,"  IIIC. Exceso o Insuficiencia en la Actualización de la Hac",0,0]
[null,null,null,null,null,null,"    Resultado por Tenencia de Activos no Monetarios",0,0]
[null,null,null,null,null,null,"    Resultado por Tenencia de Activos no Mo",0,0]
[null,null,null,null,null,null,"III. Total Hacienda Pública/Patrimonio",0,0,30494751112.540001,23623962568.759998,-29548134752.43]
[null,null,null,null,null,null,"IV. Total del Pasivo y Hacienda Pública/Patrimonio",0,0,56247866992.989998,51197291214.550003,-55990709954.349998]

{"sheet":"Estado Situacion Financiera Det","index":3,"n_rows":83,"n_cols":26,"rows_kept":83,"cut":false,"hidden":false,"merged":[[2,1,2,7],[3,1,3,7],[4,1,4,7],[6,1,6,7],[5,1,5,8]]}
["2018","1..12",null,"Gob del Edo de Michoacán",null,"16/10/2018","Selección vacía","12","Enero","Diciembre","1","2018-12-31",31,null,null,null,null,null,null,"12","2017","1..12","4to Trimestre 2018","4to Trimestre 2017","12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1..12"]
[null,"GOBIERNO DEL ESTADO DE MICHOACÁN DE OCAMPO",null,null,null,null,null,null,null,null,null,"H",null,"009.2019"]
[null,"Estado de Situación Financiera Detallado - LDF",null,null,null,null,null,null,null,null,null,"L",null,"016.2018",null,null,null,null,null,null,"Actual","12",12,"Diciembre",1,"Enero"]
[null,"Al 30 de Septiembre del 2019 y al 31 de Diciembre del 2018",null,null,null,null,null,null,null,null,null,null,null,"24/01/2019",null,null,null,null,null,null,"Anterior","12",12,"Diciembre",2,"Febrero"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Marzo"]
[null,"(Pesos)",null,null,null,null,null,null,null,null,null,"L",null,"16",16,"Diciembre",null,null,1,"Enero","ct",null,null,null,5,"Mayo"]
[null,"Concepto (c)","Septiembre 2019","Diciembre 2018",null,"Concepto (c)","Septiembre 2019","Diciembre 2018",null,null,null,"DIA CONSULTA",null,"24",24,null,null,null,2,"Febrero","An",null,null,null,6,"Junio"]
[null,"ACTIVO",null,null,null,"PASIVO",null,null,null,null,null,"MES CONSULTA",null,"01",1,"Enero",null,null,3,"Marzo","er",null,null,null,7,"Julio"]
[null,"Activo Circulante",null,null,null,"Pasivo Circulante",null,null,null,null,null,"AÑO CONSULTA",null,"2019",2019,null,null,null,4,"Abril","or",null,null,null,8,"Agosto"]
[null,"  a. Efectivo y Equivalentes  (a=a1+a2+a3+a4+a5+a6+a7)",4861883606.6100006,2221588920.1100001,null,"a. Cuentas por Pagar a Corto Plazo (a=a1+a2+a3+a4+a5+a6+a7+a8+a9)",{"$f":"SUM(G12:G20)","v":6245290884.5200005},5957743888.4899998,null,null,null,null,null,"2018",2018,null,null,null,5,"Mayo",null,null,null,null,9,"Septiembre"]
[null,"    a1) Efectivo",1393323329.46,583704758.58000004,null,"    a1) Servicios Personales por Pagar a Corto Plazo",341914190.55000001,427068145,null,null,null,null,null,null,null,null,null,null,6,"Junio",null,null,null,null,10,"Octubre"]
[null,"    a2) Bancos/Tesorería",3050010423.3899999,1636771067,null,"    a2) Proveedores por Pagar a Corto Plazo",{"$f":"888222693.88+1635629.28","v":889858323.15999997},1391584150.02,null,null,null,"AÑO LOW ",null,"2018",null,null,null,null,7,"Julio","al",null,null,null,11,"Noviembre"]
[null,"    a3) Bancos/Dependencias y Otros",0,0,null,"    a3) Contratistas por Obras Públicas por Pagar a Corto Plazo",51499469.07,278284519,null,null,null,"AÑO HIGH",null,"2019",null,null,null,null,8,"Agosto","",null,null,null,12,"Diciembre"]
[null,"    a4) Inversiones Temporales (Hasta 3 meses)",1133935.9099999999,1084088.53,null,"    a4) Participaciones y Aportaciones por Pagar a Corto Plazo",144541572.72,168115975.56,null,null,null,null,null,null,null,null,null,null,9,"Septiembre"]
[null,"    a5) Fondos con Afectación Específica",417386911.85000002,0,null,"    a5) Transferencias Otorgadas por Pagar a Corto Plazo",1044704214.0599999,786381168.23000002,null,null,null,"01/09/2019",null,"01/Septiembre/",null,null,null,null,10,"Octubre"]
[null,"    a6) Depósitos de Fondos de Terceros en Garantía y/o  Administración",0,0,null,"    a6) Intereses, Comisiones y Otros Gastos de la Deuda Pública por Pagar a Corto Plazo",6805285.0599999996,6263645.79,null,null,null,"2019-09-30",null,{"$error":"#VALUE!"},null,null,null,null,11,"Noviembre"]
[null,"    a7) Otros Efectivos y Equivalentes",29006,29006,null,"    a7) Retenciones y Contribuciones por Pagar a Corto Plazo",1477094594.9200001,1368271953.0999999,null,null,null,null,null,null,null,null,null,null,12,"Diciembre"]
[null,"  b. Derechos a Recibir Efectivo o Equivalentes (b=b1+b2+b3+b4+b5+b6+b7)",5179794576.3100004,2890381899.8000002,null,"    a8) Devoluciones de la Ley de Ingresos por Pagar a Corto Plazo",6941012.3499999996,12038276.789999999,null,null,null,"01/12/2018",null,null,null,null,null,null,13,"Diciembre"]
[null,"    b1) Inversiones Financieras de Corto Plazo",-0.05,1224815.6599999999,null,"    a9) Otras Cuentas por Pagar a Corto Plazo",2281932222.6300001,1519736055,null,null,null,"2018-12-31",null,null,null,null,null,null,14,"Diciembre"]
[null,"    b2) Cuentas por Cobrar a Corto Plazo",99588109.969999999,99588109.969999999,null,"b. Documentos por Pagar a Corto Plazo (b=b1+b2+b3)",1811250000,3750582880,null,null,null,null,null,null,null,null,null,null,15,"Diciembre"]
[null,"    b3) Deudores Diversos por Cobrar a Corto Plazo",4548475347.8800001,2421868811,null,"    b1) Documentos Comerciales por Pagar a Corto Plazo",1811250000,3750582880,null,null,null,"30",null,{"$error":"#VALUE!"},null,null,null,null,16,"Diciembre"]
[null,"    b4) Ingresos por Recuperar a Corto Plazo",14458429.15,14751538.130000001,null,"    b2) Documentos con Contratistas por Obras Públicas por Pagar a Corto Plazo",0,0,null,null,null,"31"]
[null,"    b5) Deudores por Anticipos de la Tesorería a Corto Plazo",47615245.520000003,38353502.740000002,null,"    b3) Otros Documentos por Pagar a Corto Plazo",0,0]
[null,"    b6) Préstamos Otorgados a Corto Plazo",47149642.299999997,47149642.299999997,null,"c. Porción a Corto Plazo de la Deuda Pública a Largo Plazo (c=c1+c2)",{"$f":"SUM(G26:G27)","v":129979541.05},461527733.06999999,null,null,null,"Al 30 de Septiembre del 2019 y al 31 de Diciembre del 2018"]
[null,"    b7) Otros Derechos a Recibir Efectivo o Equivalentes a Corto Plazo",422507801.54000002,267445480,null,"    c1) Porción a Corto Plazo de la Deuda Pública",{"$f":"131615170.33-1635629.28","v":129979541.05},461527733.06999999,null,null,null,"Al 30 de Diciembre del 2018 y al 30 de Septiembre del 2019"]
[null,"  c. Derechos a Recibir Bienes o Servicios (c=c1+c2+c3+c4+c5)",17733825.34,107853768.78,null,"    c2) Porción a Corto Plazo de Arrendamiento Financiero",0,0]
[null,"     c1) Anticipo a Proveedores por Adquisición de Bienes y Prestación de Servicios a Corto Plazo",0,0,null,"d. Títulos y Valores a Corto Plazo",0,0]
[null,"    c2) Anticipo a Proveedores por Adquisición de Bienes Inmuebles y Muebles a Corto Plazo",0,0,null,"e. Pasivos Diferidos a Corto Plazo (e=e1+e2+e3)",0,0]
[null,"    c3) Anticipo a Proveedores por Adquisición de Bienes Intangibles a Corto Plazo",0,0,null,"    e1) Ingresos Cobrados por Adelantado a Corto Plazo",0,0]
[null,"    c4) Anticipo a Contratistas por Obras Públicas a Corto Plazo",17733825.34,107853768.78,null,"    e2) Intereses Cobrados por Adelantado a Corto Plazo",0,0]
[null,"    c5) Otros Derechos a Recibir Bienes o Servicios a Corto Plazo",0,0,null,"    e3) Otros Pasivos Diferidos a Corto Plazo",0,0]
[null,"d. Inventarios (d=d1+d2+d3+d4+d5)",0,0,null,"f. Fondos y Bienes de Terceros en Garantía y/o Administración a Corto Plazo (f=f1+f2+f3+f4+f5+f6)",224089025.56999999,230227926.66]
[null,"    d1) Inventario de Mercancías para Venta",0,0,null,"    f1) Fondos en Garantía a Corto Plazo",11906824.58,11872039.58]
[null,"    d2) Inventario de Mercancías Terminadas",0,0,null,"    f2) Fondos en Administración a Corto Plazo",212182200.99000001,218355887.08000001]
[null,"    d3) Inventario de Mercancías en Proceso de Elaboración",0,0,null,"    f3) Fondos Contingentes a Corto Plazo",0,0]
[null,"    d4) Inventario de Materias Primas, Materiales y Suministros para Producción",0,0,null,"    f4) Fondos de Fideicomisos, Mandatos y Contratos Análogos a Corto Plazo",0,0]
[null,"    d5) Bienes en Tránsito",0,0,null,"    f5) Otros Fondos de Terceros en Garantía y/o Administración a Corto Plazo",0,0]
[null,"e. Almacenes",638414.19999999995,698324.4,null,"    f6) Valores y Bienes en Garantía a Corto Plazo",0,0]
[null,"f. Estimación por Pérdida o Deterioro de Activos Circulantes (f=f1+f2)",0,0,null,"g. Provisiones a Corto Plazo (g=g1+g2+g3)",0,0]
[null,"    f1) Estimaciones para Cuentas Incobrables por Derechos a Recibir Efectivo o Equivalentes",0,0,null,"    g1) Provisión para Demandas y Juicios a Corto Plazo",0,0]
[null,"    f2) Estimación por Deterioro de Inventarios",0,0,null,"    g2) Provisión para Contingencias a Corto Plazo",0,0]
[null,"g. Otros Activos Circulantes (g=g1+g2+g3+g4)",75108659.879999995,394589219.87,null,"    g3) Otras Provisiones a Corto Plazo",0,0]
[null,"    g1) Valores en Garantía",75108659.879999995,394589219.87,null,"h. Otros Pasivos a Corto Plazo (h=h1+h2+h3)",514890237.31,345630025.56999999]
[null,"    g2) Bienes en Garantía (excluye depósitos de fondos)",0,0,null,"    h1) Ingresos por Clasificar",2605281.04,2476374.86]
[null,"    g3) Bienes Derivados de Embargos, Decomisos, Aseguramientos y Dación en Pago",0,0,null,"    h2) Recaudación por Participar",478346638.50999999,153892509]
[null,"    g4) Adquisición con Fondos de Terceros",0,0,null,"    h3) Otros Pasivos Circulantes",33938317.759999998,189261141.71000001]
[]
[null,"IA. Total de Activos Circulantes (IA = a + b + c + d + e + f + g)",10135159082.340002,5615112132.9599991,null,"IIA. Total de Pasivos Circulantes (IIA = a + b + c + d + e + f + g + h)",{"$f":"+G11+G21+G25+G28+G29+G33+G40+G44","v":8925499688.4500008},10745712453.789999]
[]
[null,"Activo No Circulante",null,null,null,"Pasivo No Circulante"]
[null,"a. Inversiones Financieras a Largo Plazo",11690592336.23,11002813539.110001,null,"a. Cuentas por Pagar a Largo Plazo",0,0]
[null,"b. Derechos a Recibir Efectivo o Equivalentes a Largo Plazo ",188957243.97999999,175533492.78999999,null,"b. Documentos por Pagar a Largo Plazo",0,0]
[null,"c. Bienes Inmuebles, Infraestructura y Construcciones en Proceso ",14669656681.950001,14398312859.290001,null,"c. Deuda Pública a Largo Plazo",16827616192,16827616192]
[null,"d. Bienes Muebles ",2800916666.1399999,2721731355.0300002,null,"d. Pasivos Diferidos a Largo Plazo",0,0]
[null,"e. Activos Intangibles ",51869060.130000003,51836953.649999999,null,"e. Fondos y Bienes de Terceros en Garantía y/o en Administración a Largo Plazo",0,0]
[null,"f. Depreciación, Deterioro y Amortización Acumulada de Bienes ",-732137726.67999995,-564929011.46000004,null,"f. Provisiones a Largo Plazo",0,0]
[null,"g. Activos Diferidos",32457644.670000002,32457644.670000002]
[null,"h. Estimación por Pérdida o Deterioro de Activos no Circulantes",0,0,null,"IIB. Total de Pasivos No Circulantes (IIB = a + b + c + d + e + f)",16827616192,16827616192]
[null,"i. Otros Activos no Circulantes",0,0]
[null,null,null,null,null,"II. Total del Pasivo (II = IIA + IIB)",{"$f":"+G49+G59","v":25753115880.450001},27573328645.790001]
[null,"IB. Total de Activos No Circulantes (IB = a + b + c + d + e + f + g + h + i)",28702311906.419998,27817756833.080002]
[null,null,null,null,null,"HACIENDA PÚBLICA/PATRIMONIO"]
[null,"I. Total del Activo (I = IA + IB)",38837470988.760002,33432868966.040001]
[null,null,null,null,null,"IIIA. Hacienda Pública/Patrimonio Contribuido (IIIA = a + b + c)",20673380847.639999,20521064614.09]
[null,null,null,null,null,"a. Aportaciones",20667806292.290001,20515490058.740002]
[null,null,null,null,null,"b. Donaciones de Capital",0,0]
[null,null,null,null,null,"c. Actualización de la Hacienda Pública/Patrimonio",5574555.3499999996,5574555.3499999996]
[]
[null,null,null,null,null,"IIIB. Hacienda Pública/Patrimonio Generado (IIIB = a + b + c + d + e)",-7589025739.3299999,-14661524293.839998]
[null,null,null,null,null,"a. Resultados del Ejercicio (Ahorro/ Desahorro)",6718472310.2299995,2944201639.4699998]
[null,null,null,null,null,"b. Resultados de Ejercicios Anteriores",3102897954.6700001,158696315.19999999]
[null,null,null,null,null,"c. Revalúos",0,0]
[null,null,null,null,null,"d. Reservas",0,0]
[null,null,null,null,null,"e. Rectificaciones de Resultados de Ejercicios Anteriores",-17410396004.23,-17764422248.509998]
[]
[null,null,null,null,null,"IIIC. Exceso o Insuficiencia en la Actualización de la Hacienda Pública/Patrimonio (IIIC=a+b)",0,0]
[null,null,null,null,null,"a. Resultado por Posición Monetaria",0,0]
[null,null,null,null,null,"b. Resultado por Tenencia de Activos no Monetarios",0,0]
[]
[null,null,null,null,null,"III. Total Hacienda Pública/Patrimonio (III = IIIA + IIIB + IIIC)",13084355108.309999,5859540320.2500019]
[]
[null,null,null,null,null,"IV. Total del Pasivo y Hacienda Pública/Patrimonio (IV = II + III)",{"$f":"+G61+G81","v":38837470988.760002},33432868966.040001]

{"sheet":"Graph","index":4,"n_rows":48,"n_cols":12,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,"FEP8Qry3"]
[null,null,null,null,null,null,null,"Autor","ADVJYNOQUIO",null,"Actualidad datos (fecha)","14:01:09"]
[]
[]
[null,null,null,null,null,null,"Information"]
[null,null,null,null,null,null,"Autor","ADVJYNOQUIO",null,"Últ.actual.pantalla","29/10/2019 11:34:50"]
[null,null,null,null,null,null,"Usuario actual","GRPAARROYO",null,"Fe.clave","29/10/2019"]
[null,null,null,null,null,null,"Modificado por","ADVIVIEYRA",null,"Hora de modificación","24/01/2019 17:25:44"]
[null,null,null,null,null,null,"InfoSitio","ZVRL_MP02",null,"Actualidad de datos","24/01/2019 14:01:09"]
[null,null,null,null,null,null,"Nombre técnico query","ZFI_VRL_MP02_Q008A",null,"Actualidad datos (fecha)","24/01/2019"]
[null,null,null,null,null,null,"Descripción query","Estado de Situacion Financiera Det A",null,"Actualidad datos (fecha)","14:01:09"]
[]
[]
[null,null,"Filter",null,null," "]
[null,null,"Área funcional","",null," "]
[null,null,"Centro de beneficio","",null," "]
[null,null,"Centro de coste","",null," "]
[null,null,"Ejercicio/Período","",null," "]
[null,null,"Ejercicio","",null," "]
[null,null,"Estruct.","",null," "]
[null,null,"Período contable","",null," "]
[null,null,"Ratios","",null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]